SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Fantastic Lebanon Location! This charming, well-maintained, and updated 4-bedroom (3 on the tax card), 1.75-bath property is just a short walk from stores, restaurants, and the Lebanon Opera House. Reach Dartmouth College and downtown Hanover or the Dartmouth Hitchcock Medical Center in about 10 minutes. The first floor features hardwood floors throughout with radiant heating, a kitchen that includes a large breakfast bar and a 3-season porch directly off it, a bonus room (office, dining nook, etc.), a full bath, and a separate laundry room. The front of the home consists of open living and dining areas with lovely, freshly painted trim and crown moldings. Upstairs, you'll find 4 bedrooms and a 3/4 bath, all with new lighting, gleaming floors, and fresh paint. Further up is a walk-up space for storage or a cozy getaway. The basement houses your utilities with plenty of room for a workbench or storage. Outside, you will find space for gardens, complete with irrigation, and a newly roofed garage for your toys or vehicle. Come and see for yourself! Open House Sat. 4/12 1:00 pm - 3:00 PM. See you there!
Description:Stunning New Hampshire Lakefront! Beautiful water views, mountain views, bald eagle sightings and the haunting call of the loons are just a few of the things you will experience from this rustic camp perched on 94 feet of waterfront on the eastern bank of Mascoma Lake. Camp out in the existing cottage and enjoy the raised detached deck area, sandy beach bottom and private dock. What could be more delightful than summers boating with friends and family, fishing and swimming from your private dock or just watching the passing sailboats. This magical location can be used just as it is or it could be the site of your new Lakefront Dream House! Much of the preliminary leg work has been completed with survey and perking information available. This is a must see property just in time for summer fun! Open House Sat 4/12 9-11 and Sun 4/13 11-1
Description:Move-in ready and fully remodeled, this 3-bedroom, 2-bathroom Raised Ranch offers modern comfort with thoughtful upgrades. Recent improvements include a new asphalt roof (2024), mini-splits (2023), and custom kitchen with quartz countertops, ample cabinetry, and a spacious island. Additional upgrades include luxury vinyl plank flooring, a new PEX plumbing, a new hot water heater, relined chimney, and refurbished pellet stoves. The main level has three bedrooms and an updated full bathroom, while the lower level offers three flexible rooms—ideal for an office, playroom, or gym—plus a newly updated bathroom. OPEN HOUSE Tuesday April 1 4-6pm.
Description:So, you're probably wondering about the whole "location, location, location" thing in real estate, right? Well, this place totally nails it! Just a hop, skip, and a 15-minute drive away from Dartmouth University and Dartmouth Hitchcock Hospital, this sweet home is calling out for someone to make it their own. It's like it's sitting there waiting for you to throw some elbow grease and love into it, and boom, you've got yourself a real gem. Now, imagine a house with an open layout that's begging for a little bit of your creative flair. Picture big ol' bedrooms that could fit a king-sized bed with room to spare, and windows that offer views that'll make you want to sit back with a cup of joe and just take it all in. Oh, and let's not forget about that monster of a barn! It's like the ultimate man cave/she shed/playhouse for the kids/party spot all rolled into one. Plus, it comes with some extra outbuildings, so you'll have enough space to store all your toys, tools, or whatever else you can think of. You're looking at over 6 acres of pure fun. You can roam around outside, build some forts, throw a frisbee, or just kick back and enjoy the fresh air. If you're feeling adventurous, you can strap on your hiking boots or fire up the ATV/snowmobile and hit the trails, which are just a 2-minute stroll from your doorstep.
Description:Charming 3 bedroom, 2 bathroom Gambrel in West Lebanon. This light and bright home offers the perfect blend of modern updates and classic charm. The first floor has a spacious layout with hardwood floors throughout, a generous foyer, living room with a pellet stove, dining room and updated kitchen. The kitchen opens to the screened porch that overlooks the back yard, a perfect spot to enjoy freshly picked raspberries and blueberries from your backyard! The second floor has three bedrooms and the full bathroom. The lower level has a large playroom, office/den and a 3/4 bathroom. A level 0.45 acre lot with a fully fenced side yard there is plenty of space for outdoor living - the perfect spot to call home! Showings by appointment Friday 3.30-5.30pm and Saturday 12-2pm